﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace DLL.TrainingCourseware
{
	/// <summary>
	/// 数据类
	/// </summary>
	/// <![CDATA[2014-8-26 11:23:13]]>
	public class Database : DataBaseBase
	{
		#region 表结构属性
		public int TRAININGID = 2;
		public int COURSEWAREID = 3;
		public int NUMBER = 4;
		#endregion 表结构属性

		public Training.Database clsTrainingDB;
		public Courseware.Database clsCoursewareDB;

		#region 构造函数
		/// <summary>
		/// 数据类构造函数
		/// </summary>
		/// <![CDATA[2014-8-26 11:23:13]]>
		public Database(System.Web.UI.Page page)
			: base("[TrainingCourseware]", page)
		{
			clsTrainingDB = new Training.Database(page);
			clsCoursewareDB = new Courseware.Database(page);

			_strSQL = "SELECT * FROM (SELECT * FROM "+strTableName+" LEFT JOIN "+clsTrainingDB.strTableName+" ON "+listStructure[TRAININGID].strName+" = "+clsTrainingDB.listStructure[ID].strName+") A LEFT JOIN "+clsCoursewareDB.strTableName+" ON "+listStructure[COURSEWAREID].strName+" = "+clsCoursewareDB.listStructure[clsCoursewareDB.ID].strName+" ";
		}
		#endregion 构造函数

	}
}
